﻿<%@ Page Title="" Language="vb" AutoEventWireup="false" MasterPageFile="~/Site.Master" CodeBehind="acclist.aspx.vb" Inherits="OAR.acclist" %>
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="FeaturedContent" runat="server">
</asp:Content>
<asp:Content ID="Content3" ContentPlaceHolderID="MainContent" runat="server">
    <p>
        <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" BackColor="#DEBA84" BorderColor="#DEBA84" BorderStyle="None" BorderWidth="1px" CellPadding="3" CellSpacing="2" DataSourceID="ClaimsDataSource" Width="957px">
            <Columns>
                <asp:CommandField ShowSelectButton="True" />
                <asp:BoundField DataField="employerNbr" HeaderText="Employer Nbr" SortExpression="employerNbr" />
                <asp:BoundField DataField="transactionDate" HeaderText="Capture Date" SortExpression="transactionDate" />
                <asp:BoundField DataField="accidentDate" HeaderText="Accident Date" SortExpression="accidentDate" />
                <asp:BoundField DataField="accidentNbr" HeaderText="Ref Nbr" InsertVisible="False" SortExpression="accidentNbr" />
                <asp:BoundField DataField="workerName" HeaderText="Name" SortExpression="workerName" />
                <asp:BoundField DataField="workerNrc" HeaderText="NRC" SortExpression="workerNrc" />
                <asp:BoundField DataField="accidentDescription" HeaderText="Description" SortExpression="accidentDescription" />
                <asp:HyperLinkField DataNavigateUrlFields="accidentNbr" DataNavigateUrlFormatString="accdetail.aspx?accidentNbr={0}" HeaderText="Add Worker Details" Text="More detail. . . ." />
                <asp:HyperLinkField DataNavigateUrlFields="workerNRC" DataNavigateUrlFormatString="addChildren.aspx?workerNRC={0}" HeaderText="Add Children Details" Text="Children Details . . ." />
            </Columns>
            <FooterStyle BackColor="#F7DFB5" ForeColor="#8C4510" />
            <HeaderStyle BackColor="#A55129" Font-Bold="True" ForeColor="White" />
            <PagerStyle ForeColor="#8C4510" HorizontalAlign="Center" />
            <RowStyle BackColor="#FFF7E7" ForeColor="#8C4510" />
            <SelectedRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="White" />
            <SortedAscendingCellStyle BackColor="#FFF1D4" />
            <SortedAscendingHeaderStyle BackColor="#B95C30" />
            <SortedDescendingCellStyle BackColor="#F1E5CE" />
            <SortedDescendingHeaderStyle BackColor="#93451F" />
        </asp:GridView>
        <asp:SqlDataSource ID="ClaimsDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:ClaimsConnectionString %>" ProviderName="<%$ ConnectionStrings:ClaimsConnectionString.ProviderName %>" SelectCommand="SELECT Form6.employerNbr, Form6.workerNrc, Form6.accidentNbr, Form6.transactionDate, Form6.accidentDate, Form6.accidentDescription, Worker.workerNrc AS Expr1, Worker.workerName FROM (Form6 INNER JOIN Worker ON Form6.workerNrc = Worker.workerNrc)
ORDER BY Form6.accidentNbr DESC"></asp:SqlDataSource>
        <br />
    </p>
</asp:Content>
